{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Actual v Target"],"not_rendered":{"charts":2},"read":"whole","date_system":"1900"}

{"sheet":"Actual v Target","index":0,"n_rows":40,"n_cols":6,"rows_kept":40}
[]
[null,"Lesson"]
[null,"Actual vs. Target Charts: Excel charts which demonstrate the comparison between actual and target performance"]
[]
[null,"Best uses for Actual vs. Target Charts:"]
[null,"1. Comparison among a group and how each performed"]
[null,"2. Comparison of time periods for performance"]
[]
[null,"Example:"]
[null,null,"Name","Sales ($)","Target ($)","Diff."]
[null,null,"Janey",{"v":24897,"d":"24,897"},{"v":33000,"d":"33,000"},{"$f":"D11-E11","v":{"v":-8103,"d":"(8,103)"}}]
[null,null,"Matthew",{"v":47666,"d":"47,666"},{"v":33000,"d":"33,000"},{"$f":"D12-E12","v":{"v":14666,"d":"14,666 "}}]
[null,null,"Alice",{"v":9950,"d":"9,950"},{"v":8500,"d":"8,500"},{"v":1450,"d":"1,450 "}]
[null,null,"Bob",{"v":13333,"d":"13,333"},{"v":10000,"d":"10,000"},{"v":3333,"d":"3,333 "}]
[null,null,"Lucy",{"v":26800,"d":"26,800"},{"v":39000,"d":"39,000"},{"v":-12200,"d":"(12,200)"}]
{"$rows_empty":18}
[null,"Try Yourself:"]
[null,null,"Name","Sales ($)","Target ($)","Diff."]
[null,null,"Moe",{"v":38152,"d":"38,152"},{"v":33000,"d":"33,000"},{"$f":"D36-E36","v":{"v":5152,"d":"5,152 "}}]
[null,null,"May",{"v":35290,"d":"35,290"},{"v":33000,"d":"33,000"},{"$f":"D37-E37","v":{"v":2290,"d":"2,290 "}}]
[null,null,"Clint",{"v":3406,"d":"3,406"},{"v":8500,"d":"8,500"},{"v":-5094,"d":"(5,094)"}]
[null,null,"Clay",{"v":5042,"d":"5,042"},{"v":10000,"d":"10,000"},{"v":-4958,"d":"(4,958)"}]
[null,null,"Ev",{"v":39485,"d":"39,485"},{"v":30000,"d":"30,000"},{"v":9485,"d":"9,485 "}]